package com.cs.beneficios.web.action;

import com.cs.beneficios.business.entity.BeneficioDAO;
//import com.cs.beneficios.business.model.BeneficiarioVO;
import com.cs.beneficios.common.ConnectionFactory;

import com.cs.beneficios.common.util.ControlExceptions;

//import com.cs.paoyer.administration.business.model.UserVO;

import java.io.IOException;

import java.sql.SQLException;

import java.util.ArrayList;
import java.util.Collection;

//import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

//import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class DetalleBeneficiosAction extends Action {
    /**This is the main action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param form The optional ActionForm bean for this request.
     * @param request The HTTP Request we are processing.
     * @param response The HTTP Response we are processing.
     */
    public ActionForward execute(ActionMapping mapping, ActionForm form, 
                                 HttpServletRequest request, 
                                 HttpServletResponse response) throws IOException, 
                                                                      ServletException {
        
        //ConnectionFactory cf = new ConnectionFactory("beneficios","beneficios");
		ConnectionFactory cf = new ConnectionFactory();
        //HttpSession session = request.getSession();
        //UserVO user = (UserVO)session.getAttribute("userInfo");
        
        String strCodeBene = request.getParameter("code");
        String strCodeSubpro = request.getParameter("codBeneficio");
        try {
            Collection coBeneficios = new ArrayList();
            BeneficioDAO objBeneDao = new BeneficioDAO(cf);
            coBeneficios = objBeneDao.getDetailsBeneficios(strCodeBene,strCodeSubpro);
            
            if(coBeneficios.size() > 0){
              request.setAttribute("beneficios",coBeneficios);
              request.setAttribute("codbene", strCodeBene);
            }
        }catch(SQLException e) {
			System.err.println("/******** TDSUB - cwsub");
			e.printStackTrace();
			System.err.println("TDSUB - cwsub ********/");
            ControlExceptions.insertException(e,cf);
        }
        
        return mapping.findForward( "success");
    }
}
